Tabela CO_L_RECIPEDICTNUTRIENT

Definicja tabeli CO_L_RECIPEDICTNUTRIENT

Name

CO_L_RECIPEDICTNUTRIENT

Code

CO_L_RECIPEDICTNUTRIENT

Comment

 


Lista kolumn tabeli CO_L_RECIPEDICTNUTRIENT

Name

Code

CO_L_RECIPEDICTNUTRIENTID

CO_L_RECIPEDICTNUTRIENTID

CO_DICTNUTRIENTID

CO_DICTNUTRIENTID

CO_RECIPEID

CO_RECIPEID

CO_DICTUNITID

CO_DICTUNITID

QUANTITY

QUANTITY

INSERTDATE

INSERTDATE

INSERTINGPERSON

INSERTINGPERSON

LASTMODIFIEDPERSON

LASTMODIFIEDPERSON

LASTMODIFIEDDT

LASTMODIFIEDDT


Kolumna CO_L_RECIPEDICTNUTRIENTID tabeli CO_L_RECIPEDICTNUTRIENT

Definicja kolumny CO_L_RECIPEDICTNUTRIENTID tabeli CO_L_RECIPEDICTNUTRIENT

Name

CO_L_RECIPEDICTNUTRIENTID

Code

CO_L_RECIPEDICTNUTRIENTID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna CO_DICTNUTRIENTID tabeli CO_L_RECIPEDICTNUTRIENT

Definicja kolumny CO_DICTNUTRIENTID tabeli CO_L_RECIPEDICTNUTRIENT

Name

CO_DICTNUTRIENTID

Code

CO_DICTNUTRIENTID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna CO_RECIPEID tabeli CO_L_RECIPEDICTNUTRIENT

Definicja kolumny CO_RECIPEID tabeli CO_L_RECIPEDICTNUTRIENT

Name

CO_RECIPEID

Code

CO_RECIPEID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna CO_DICTUNITID tabeli CO_L_RECIPEDICTNUTRIENT

Definicja kolumny CO_DICTUNITID tabeli CO_L_RECIPEDICTNUTRIENT

Name

CO_DICTUNITID

Code

CO_DICTUNITID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna QUANTITY tabeli CO_L_RECIPEDICTNUTRIENT

Definicja kolumny QUANTITY tabeli CO_L_RECIPEDICTNUTRIENT

Name

QUANTITY

Code

QUANTITY

Data Type

NUMBER(20,8)

Mandatory

Yes

Comment

Ilosc danego skladnika odzywczego w przepisie


Kolumna INSERTDATE tabeli CO_L_RECIPEDICTNUTRIENT

Definicja kolumny INSERTDATE tabeli CO_L_RECIPEDICTNUTRIENT

Name

INSERTDATE

Code

INSERTDATE

Data Type

DATE

Mandatory

No

Comment

 


Kolumna INSERTINGPERSON tabeli CO_L_RECIPEDICTNUTRIENT

Definicja kolumny INSERTINGPERSON tabeli CO_L_RECIPEDICTNUTRIENT

Name

INSERTINGPERSON

Code

INSERTINGPERSON

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna LASTMODIFIEDPERSON tabeli CO_L_RECIPEDICTNUTRIENT

Definicja kolumny LASTMODIFIEDPERSON tabeli CO_L_RECIPEDICTNUTRIENT

Name

LASTMODIFIEDPERSON

Code

LASTMODIFIEDPERSON

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna LASTMODIFIEDDT tabeli CO_L_RECIPEDICTNUTRIENT

Definicja kolumny LASTMODIFIEDDT tabeli CO_L_RECIPEDICTNUTRIENT

Name

LASTMODIFIEDDT

Code

LASTMODIFIEDDT

Data Type

DATE

Mandatory

No

Comment

 


Lista kluczy tabeli CO_L_RECIPEDICTNUTRIENT

Name

Code

Primary

PK_CO_L_RECIPEDICTNUTRIENT

PK_CO_L_RECIPEDICTNUTRIENT

X


Klucz PK_CO_L_RECIPEDICTNUTRIENT tabeli CO_L_RECIPEDICTNUTRIENT

Definicja klucza PK_CO_L_RECIPEDICTNUTRIENT tabeli CO_L_RECIPEDICTNUTRIENT

Name

PK_CO_L_RECIPEDICTNUTRIENT

Code

PK_CO_L_RECIPEDICTNUTRIENT

Primary

Yes

Comment